Dataset
Trends and Patterns
Hypothesis Testing (Impact of COVID-19 on Crime Numbers)
Heatmap in Cities
2021/06/09
Agenda
Dataset
data.acgov.org - Alameda County Open Data Hub:
## Rows: 181,869 ## Columns: 10 ## $ DateTime <chr> "2012/01/17 13:50:59+00", "2012/01/17 13:02:59+00", "… ## $ City <fct> HAYWARD, CASTRO VALLEY, SAN LEANDRO, SAN LEANDRO, CAS… ## $ Longitude <dbl> -122.1103, -122.0719, -122.1231, -122.1230, -122.0543… ## $ Latitude <dbl> 37.67695, 37.69681, 37.70154, 37.70989, 37.70560, 37.… ## $ CrimeDescription <chr> "RECOVERED STOLEN AUTO - OUTSIDE AGENCY", "DEATH UNAT… ## $ CrimeCode <chr> "R24", "999", "120", "999", "520", "999", "999", "23H… ## $ time <dttm> 2012-01-17 13:50:59, 2012-01-17 13:02:59, 2012-01-17… ## $ year <dbl> 2012, 2012, 2012, 2012, 2012, 2012, 2012, 2012, 2012,… ## $ month <yearmon> Jan 2012, Jan 2012, Jan 2012, Jan 2012, Jan 2012,… ## $ date <date> 2012-01-17, 2012-01-17, 2012-01-17, 2012-01-17, 2012…
Trends and Patterns
Trends and Patterns
Time Series for Different CrimeCode
999: 72 HOUR MENTAL HEALTH
90D: DUI ALCOHOL/DRUGS
35A: USE/UNDER INFLUENCE OF CONTROLLED SUBSTANCE
Hypothesis Testing
Test 1.
Impact of Lock Down on Alameda Crime Numbers.(Mar. 17, 2020 - May 22, 2020)
Test 2.
Impact of COVID-19 on Alameda Crime Numbers.(Jan. 1, 2020 - May 31, 2021)
Test 1 - Impact of Lock Down on Alameda Crime Numbers
Test 1 - Impact of Lock Down on Alameda Crime Numbers
\(H_0 : \mu = 53.37\)
\(H_1 : \mu \neq 53.377\)
\(\mu = 53.377\)
mean crime number per day, March 17 - May 22, 2012 - 2019.
\(\bar{x} = 39.134\)
mean crime number per day, March 17 - May 22 (lock down), 2020.
n = 67
## ## One Sample t-test ## ## data: sample_1$n_crime ## t = -13.76, df = 66, p-value < 2.2e-16 ## alternative hypothesis: true mean is not equal to 53.37687 ## 95 percent confidence interval: ## 37.06770 41.20095 ## sample estimates: ## mean of x ## 39.13433
Test 2 - Impact of COVID-19 on Alameda Crime Numbers
\(H_0 : \mu = 54.357\)
\(H_1 : \mu \neq 54.357\)
\(\mu = 54.357\)
mean crime number per day, 2012-01-01 - 2019-12-31.
\(\bar{x} = 44.157\)
mean crime number per day, 2020-01-01 - 2021-05-31.
n = 334
## ## One Sample t-test ## ## data: sample_2$n_crime ## t = -17.645, df = 516, p-value < 2.2e-16 ## alternative hypothesis: true mean is not equal to 54.35661 ## 95 percent confidence interval: ## 43.02100 45.29235 ## sample estimates: ## mean of x ## 44.15667
Mapping
Heatmap in Cities
Heatmap in Hayward
Hayward - CrimeCode
Datatable
Thanks!